<html lang="en">

<head>

	<meta charset="utf-8"/>
	<link rel="stylesheet" href="../assets/css/layout.css" type="text/css" media="screen" />
</head>

<body>

<table class="tablesorter" cellspacing="0">
			<thead> 
				<tr> 
    				<th WIDTH="35%"><center>Facility Name</center></th>
    				<th><center>Address</center></th> 					    				    				
    				<th><center>Phone Number</center></th>     				
    				<th><center>City, State</center></th>
				</tr> 
			</thead> 
			<tbody> 
			
<?php

require_once('../../auth/auth.php');
include 'db_Connect.php';
$disease=$_GET["disease"];

$result = mysql_query("SELECT * from resources WHERE SERVICE = '".$disease."' or SERVICE = 'ALL'");

while($row = mysql_fetch_array($result)){
	//Display the results in different cells
	echo 	"<tr><td WIDTH=\"35%\">" 
		. $row['FACILITY_NAME']
		. "</td><td><center>" 
		. $row['ADDRESS']
		. "</center></td><td><center>" 
		. $row['PHONE_NUMBER']
		. "</center></td><td><center>" 
		. $row['CITY']
		. ", " . $row['STATE'] 		 	
		. "</center></td></tr>";
}
include 'db_Close.php';
?>

</table>

</body>

</html>